Release 10.1A: OpenEdge Data Management:SQL Reference
REVOKE PRIVILEGE Syntax revoke privilege statement ::= REVOKE [ GRANT OPTION FOR ] { privilege [, privilege , ] , ... | ALL [ PRIVILEGES ] } ON table_name FROM { user_name [ , user_name ] , ... | PUBLIC } [ RESTRICT | CASCADE ] ; PRIVILEGE Syntax Syntax privilege ::= { SELECT | INSERT | DELETE | INDEX |UPDATE [ ( column , column , ... ) ] | REFERENCES [ ( column , column , ... ) ] }
revoke privilege statement ::= REVOKE [ GRANT OPTION FOR ] { privilege [, privilege , ] , ... | ALL [ PRIVILEGES ] } ON table_name FROM { user_name [ , user_name ] , ... | PUBLIC } [ RESTRICT | CASCADE ] ;
privilege ::= { SELECT | INSERT | DELETE | INDEX |UPDATE [ ( column , column , ... ) ] | REFERENCES [ ( column , column , ... ) ] }